SELECT Id FROM new_searchtable
where (town like 'Lyme' or town like 'Enfield' or town like 'Plainfield' or town like 'Cornish') and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley NH Homes page 20
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Welcome to this charming brick Cape nestled near the top of Pinnacle Road, a lovingly transformed retreat rich in character. Antique home enthusiasts will appreciate its unique history, incorporating part of an old schoolhouse and showcasing delightful details throughout. The home features five bedrooms, including two on the main floor, and four baths (two ensuite), offering versatile living spaces. Highlights include antique wide pine floors, original fireplaces with stone hearths, exposed beams, high ceilings, and a spacious great room with a gas fireplace. The country kitchen with a cozy breakfast nook offers views of the Green Mountains, while the formal dining room is perfect for gatherings. There are both formal and informal living areas, and numerous elements that enhance the home’s appeal. Outside, the beauty of the property extends in every direction. Facing west, enjoy long-range views of the Vermont hills and stunning sunsets. A patio off the kitchen provides a lovely spot for outdoor dining while taking in the changing scenery. Set on 10 acres, the land includes open fields, a small wooded area with a trail loop, and a stream that adds tranquility to the setting. Additional features include a detached two-car garage with storage and workshop, a pole barn for equipment or animals (or events!), and a smaller three-bay run-in shed. Perennial gardens, maple trees, and hardscaping further enhance this breathtaking location atop Pinnacle Road.
Description:Discreetly tucked away to ensure privacy and leisure, this Mascoma Lake estate has it all. A rare opportunity on Mascoma Lake, this property has a grandfathered boathouse to store all your toys. Leading you out of the boathouse is your own personal dock. When you aren’t on your boat exploring the lake, sit on the oversized deck and soak in the views. An ideal location for hosting all of your get-togethers. The 180 degree views from every room allows pure natural light to permeate through this home. With the ability to connect to the town sewer system, this 3 bedroom home has the opportunity to be a 5+ bedroom home. Should you seek an in-law suite/studio, there is a bonus suite on the upper level that is plumbed for a kitchen. The basement contains finished space with a partial kitchen, allowing convenience for your hosting needs. This is luxury living.